<style type="text/css">
body {
	background-color: #FFA500;
}
body,td,th {
	color: #1C1C1C;
}
</style>

<?php
$con = mysql_connect("localhost","root","1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("northwindDB", $con);




$result = mysql_query("SELECT * FROM  nwcustomers " );
echo '<center>' ;
  echo  '<br><h1>Customers</h1><hr><br>';
  echo '<table width="200" border="2">';
  echo '<tr><td bgcolor="#C1CDC1">' . 'CustomerID'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'CompanyName'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ContactTitle'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'Address'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'City'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'Region'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'PostalCode'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'Country'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'Phone'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'Fax'. '</td></tr>';

while($row = mysql_fetch_array($result))
  {
  echo '<tr><td bgcolor="#C1CDC1">' .  $row['CustomerID'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['CompanyName'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ContactTitle'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['Address'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['City'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['Region'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['PostalCode'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['Country'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['Phone'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['Fax'] . '</td></tr>';
  //echo "<br />";

  }
  echo '</table>';
  echo '</center>' ;
mysql_close($con);
?>